﻿CREATE PROCEDURE [dbo].[proc_Roles_UsersInRoles]
AS
	Select
	UserId,
	isnull((Select UserName From aspnet_Users Where UserId=aspnet_UsersInRoles.UserId),'...') As UserName,
	RoleId
	From aspnet_UsersInRoles
	RETURN
